CREATE TABLE [dbo].[Comment_Log]
(
[COMMENT_LOG_NUM] [int] NOT NULL CONSTRAINT [DF_Comment_Log_COMMENT_LOG_NUM] DEFAULT ((0)),
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Comment_Log_ID] DEFAULT (''),
[FROM_EMAIL] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Comment_Log_FROM_EMAIL] DEFAULT (''),
[SUBJECT] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Comment_Log_SUBJECT] DEFAULT (''),
[COMMENT_TYPE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Comment_Log_COMMENT_TYPE] DEFAULT (''),
[CREATE_DATE] [datetime] NULL,
[PROCESSED] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Comment_Log_PROCESSED] DEFAULT (''),
[COMMENT_CONTENT] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Comment_Log] ADD CONSTRAINT [PK_Comment_Log] PRIMARY KEY NONCLUSTERED ([COMMENT_LOG_NUM]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iComment_LogCOMMENT_TYPE] ON [dbo].[Comment_Log] ([COMMENT_TYPE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Comment_Log] TO [IMIS]
GRANT SELECT ON  [dbo].[Comment_Log] TO [IMIS]
GRANT INSERT ON  [dbo].[Comment_Log] TO [IMIS]
GRANT DELETE ON  [dbo].[Comment_Log] TO [IMIS]
GRANT UPDATE ON  [dbo].[Comment_Log] TO [IMIS]
GO